-- User Creation Scripts

-- Create Login
CREATE LOGIN <user_name> WITH PASSWORD='<password>', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF;

-- Set the Schema
ALTER USER <user_name> WITH DEFAULT_SCHEMA = dbo;

-- Create the User for the database
CREATE USER <user_name> FOR LOGIN <user_name> WITH DEFAULT_SCHEMA = dbo;

-- Add a user to a role
EXEC sp_addrolemember '<role_name>', '<user_name>'

